SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003226 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003226 [ RunTime:0.001410s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (56856,522605,1035751,493611,141501,102508,454936,506656,853061,175205,43376,65902,247483,497294,258115,796123,152181,827507,840529,1026360,138126,773278,828380,517850,606071,1000632,679911,1000928,261538,650913,474237,514108,909471,311527,670691,497903,478000,919889,301633,614582,55145,292045,717286,305252,44101,789183,724521,862235,678034,639654,494008,54925,486428,801070,992359,105758,103582,17209,2685,621924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]