SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027850 LIMIT 1 [ RunTime:0.001788s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027850 [ RunTime:0.001793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124747,894736,918048,441284,510164,394427,684909,627935,966189,20332,300268,827920,301582,400935,108573,132199,1023550,376933,517564,114735,811345,208451,799061,614862,161888,968333,892954,464582,462439,660282,211307,642494,370036,53043,670936,686960,403186,542051,655241,56949,831992,293399,595510,758701,894442,388594,476622,689082,365806,568884,100448,408515,531732,219823,608631,375146,696202,292489,161840,823464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002994s ]