SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555517 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555517 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130060,816766,44056,164098,404264,249973,229614,590177,415556,528879,749521,128094,205763,234636,163129,473776,321928,459937,1010838,184535,225820,1032782,903700,639632,20845,989098,73427,455114,98432,1015758,401941,794636,773246,754555,740829,191936,608062,34134,376258,770455,889474,303887,311281,685030,843103,147299,661386,955300,395202,457363,913922,116108,1048398,568647,99609,961757,418972,421934,578880,179360) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]