SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001854s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518030 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518030 [ RunTime:0.002402s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (25050,407566,235327,6143,295955,217731,280105,569927,762224,755651,640151,696589,348741,40456,424034,958430,799458,22348,58848,327346,303210,723000,132677,398016,673118,12295,725071,563047,983130,294154,44900,258827,1005682,647497,1034162,825636,114683,433569,851496,626335,29622,743877,349683,271381,990988,447682,693723,922034,980057,41873,973703,893747,1033916,765054,617599,792691,972472,792643,571751,866532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]