SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018890 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018890 [ RunTime:0.002132s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (658296,200019,74751,514084,981707,709622,786473,18746,645776,808758,559909,65021,935287,500637,420942,673234,728702,17505,982976,227863,176415,655183,572036,439269,17074,368442,678670,475400,359740,901960,969942,519504,650139,829679,927656,45816,481717,338100,433025,381460,262955,326031,80056,993699,694251,407069,36220,463067,248292,5558,560947,183891,913659,899656,200389,949334,291855,360237,339977,141109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.017625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]