SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 822003 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 822003 [ RunTime:0.001882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788855,530713,554876,1020026,534140,563594,443445,57877,591383,932368,179593,537298,795923,1011442,379612,530003,700976,166975,957237,543358,803060,541862,386641,178969,769993,999333,860601,1043133,301596,377331,114280,280203,362236,511862,403255,310329,789100,872390,825695,1035717,203176,129915,933428,897700,180760,790525,450762,646015,703116,25867,767174,589212,295992,109390,157867,309847,815295,867693,920939,946614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 822003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 822003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]