SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427094 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427094 [ RunTime:0.004707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (45399,181908,731943,327339,548005,751672,879177,745420,15231,820878,854164,245678,542803,431885,339093,619828,912334,824104,709690,448373,971841,1025525,198663,105041,431706,139026,155734,516597,27164,969585,598920,231712,131990,136012,318492,688863,235671,457317,570681,832656,950387,58590,96405,630997,516771,774231,90492,3849,791490,667219,3478,924364,840626,626384,257684,60253,849090,947262,383674,826578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]