SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447340 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447340 [ RunTime:0.002466s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (668084,427544,1010306,715425,905591,942344,519656,429029,990040,917555,673566,472674,573715,118346,470494,885404,196420,102491,126036,234742,847146,482546,333395,197678,518505,831564,158808,786418,208072,819673,111884,516500,482762,886788,438609,614884,441106,890554,955921,397812,804537,488491,215582,262495,511326,54239,617549,563963,542453,492987,350185,324912,578546,847224,149355,115052,1024665,430905,1008804,13071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447340 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447340 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000983s ]