SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422449 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422449 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510957,441089,317197,885893,563686,894422,762220,154199,681251,911736,149182,854420,864894,335245,733243,406186,941420,239393,4424,737014,208636,743469,452333,1038053,199567,34338,68520,878321,763821,736125,28879,860087,296857,465684,307420,837593,561707,67729,98,150163,970371,1010338,856967,796222,92644,1047525,263279,529618,143253,1029117,911138,530776,353240,371423,388259,245377,655408,626066,780236,210986) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422449 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422449 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]