SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020037 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020037 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (792453,800476,288497,880480,912529,783502,589128,835615,281549,950426,677394,15654,494027,533616,1029852,266783,161961,729057,805916,1048098,669529,149799,937615,426446,542201,993722,499909,78019,309894,3271,271574,288556,599989,729914,142009,259635,704106,961242,84403,651508,903735,1009602,464765,199745,800136,643753,759177,764398,472047,937512,500058,257666,619140,887670,199998,185295,393477,74358,166026,723532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006744s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020037 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020037 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001745s ]