SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565976 LIMIT 1 [ RunTime:0.005023s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565976 [ RunTime:0.006168s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447990,219312,830758,167288,864677,218274,327336,459320,414885,1035904,482059,1033635,33821,215371,286456,111998,894617,1017734,747832,164271,940884,266073,203039,75745,258373,94393,403201,163676,721153,766391,194427,306643,788874,611389,722958,1018139,681181,559276,56771,790246,989138,511429,221830,694359,44448,388789,20977,294231,595012,499814,645045,1045228,800247,104334,68094,679383,993221,710684,1012411,773442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]