SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567259 LIMIT 1 [ RunTime:0.000632s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567259 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149188,723613,980023,4879,603521,900268,131276,687886,562667,639670,165969,148728,427492,851999,1038078,940626,588605,827345,119713,632983,723014,271423,91168,264483,433561,237789,918883,1021731,855363,536330,221611,241748,266330,700290,1010843,861714,378100,354880,511692,840581,786211,313684,135277,721665,864794,788668,450137,111396,183946,928574,206694,600189,977345,799908,908794,194272,829225,117673,865822,19858) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567259 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567259 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]