SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042588 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042588 [ RunTime:0.002025s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314271,44712,717789,1032366,50492,219382,636295,163284,555247,360847,801976,946589,76244,785642,45050,542991,979623,1031735,713748,822244,797587,557786,1020100,679820,224675,254212,751267,404985,428426,636889,67353,533603,828585,892649,217268,608794,701379,680236,1046971,1019347,794816,515226,896845,547369,571851,459558,818277,789689,719832,470159,376560,841562,829800,368646,195305,592828,627554,736082,1005619,686318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042588 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042588 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000722s ]