SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334941 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334941 [ RunTime:0.001590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427159,82942,151805,54871,759006,953855,881973,996184,849940,555531,524125,578252,720691,1026749,555615,424876,522700,58615,738358,670321,727721,905022,242746,1038394,961923,807713,294166,705291,682716,178059,610236,330513,723576,433100,870915,373583,152090,804951,256833,363342,1028345,419764,1046370,359828,342617,307932,484017,242071,861706,283858,1047588,136872,473807,358729,887342,863324,631424,354588,71489,87291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]