SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001536s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026576 LIMIT 1 [ RunTime:0.000549s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026576 [ RunTime:0.003730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (707643,509412,942075,674536,25950,729188,270679,796841,753389,118500,55793,407530,601562,647857,826219,336296,60693,227226,798283,108302,720995,203511,255885,51904,505734,385238,543013,822305,406416,510498,62214,24180,920318,820762,1027747,848684,31945,483804,58388,984329,394362,871341,135192,859479,426331,551050,889653,1046170,90372,614750,412549,272411,864025,959700,121193,218501,854775,663308,926497,327915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026576 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026576 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]