SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002931s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457245 LIMIT 1 [ RunTime:0.002091s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457245 [ RunTime:0.006030s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327552,1014759,438117,1021984,407176,789377,1028346,837441,140390,318109,821120,681447,885241,230539,117223,665198,793950,168423,886843,94733,742126,939421,67196,34434,335768,881564,277512,752936,812528,635102,208459,81531,791245,1005615,221881,501937,873490,711071,292410,607162,505838,79847,844440,969616,272631,745488,841333,355824,194433,509757,302920,373114,298243,643696,984620,990441,188855,897421,233355,929083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457245 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457245 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]