SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001409s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045491 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045491 [ RunTime:0.004262s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (268916,763160,860594,791023,252885,16453,726784,239395,863642,1040311,579894,805562,863862,555447,747000,1030214,387030,1042656,80380,408745,126588,256320,329653,647027,655524,640145,293061,633843,879898,254369,481260,989948,78590,750078,855088,890847,423285,477736,54495,792537,320028,785748,313591,126183,61639,548831,413538,658729,1033038,133328,265302,920690,914597,395624,122685,791099,257840,731352,253291,169171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002431s ]