SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 941194 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 941194 [ RunTime:0.006639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046609,691661,725710,297832,718299,245799,172218,554920,708210,752943,118919,495878,719585,974833,466321,932365,580934,337680,941126,538839,1018008,961236,117000,1033141,340775,124798,448055,1002547,976240,448440,21301,37395,799841,361551,1041192,306581,465062,41573,390490,885579,1016989,155656,897299,669429,827280,470609,229814,71488,262876,862725,533739,261262,757684,792347,376548,465784,966702,794007,338109,355346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 941194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 941194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]