SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 159481 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 159481 [ RunTime:0.004298s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502977,256187,72085,455105,275804,1008349,413653,199248,1030057,401708,126108,920800,298680,748091,353069,271419,560362,393056,731083,237873,166072,187151,567569,1020900,801509,343561,689823,285186,426377,756545,116668,1007761,821752,944744,83936,896329,999279,184456,487996,95051,272538,134125,159224,292108,460815,808071,794158,60285,21489,786634,449181,316097,118360,291437,782520,812466,47165,774056,992078,842036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 159481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 159481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]