SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012318 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012318 [ RunTime:0.002553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406218,789574,681747,885655,698811,391838,962818,834625,658757,523356,562796,202217,603178,209025,863613,982663,312639,1020458,572961,43200,1030427,170811,799178,197540,1029832,494604,299261,612959,978377,440335,482470,837678,114345,568434,545231,839993,203994,94072,885530,177931,320050,971241,376159,1026836,766528,129481,200860,45315,906016,661793,949925,679046,214047,989645,890822,273184,106749,208405,481926,723993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001580s ]