SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38513 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38513 [ RunTime:0.001857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (980195,222649,559339,904945,102953,85995,618987,201666,186743,60837,594441,741358,821950,60703,855830,192478,347490,4011,879932,60466,185038,46796,152692,346971,926511,4269,360738,722143,415351,112671,639583,420103,642337,787079,73262,126590,113293,156156,642666,799144,942363,121978,802918,699021,363188,625356,979504,511738,711212,97184,279332,192027,695648,1001041,231394,537447,342572,204987,98583,61866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]