SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493791 LIMIT 1 [ RunTime:0.000278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493791 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (64577,400455,273659,715262,1033259,51061,1036015,138628,387135,193865,686914,73137,306633,418326,463547,231990,22029,1035588,252328,274918,1025780,1018278,496527,126759,437107,499368,919385,694079,466897,404567,59660,39466,520743,1044227,156537,937342,871792,343049,1003753,182372,1001496,539053,669966,754140,563976,848403,599400,550633,112015,363432,16189,239423,794184,992741,967902,154804,25464,1044256,339472,56985) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002756s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001636s ]