SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540438 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540438 [ RunTime:0.002179s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3802,137471,363421,344704,532632,860775,670904,861850,780151,260423,949496,150160,430153,279579,831122,1035290,440376,642812,113896,562308,805831,1045248,486474,696205,783592,1019726,395621,718559,462691,787254,511328,969949,105854,404634,1003867,689013,701129,436561,299342,156983,791663,294484,719295,12097,325450,971357,723799,129162,200434,287472,147476,421155,890274,53179,967502,1022820,418732,1043531,62965,909608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002671s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000385s ]