SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002708s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406393 LIMIT 1 [ RunTime:0.002366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406393 [ RunTime:0.006348s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (668313,574212,161580,600558,700052,537108,814985,1003464,463478,821419,722266,1014107,7592,1023884,927888,65410,233174,460386,1005058,378511,391963,153690,220028,53384,124998,246925,716986,178984,912815,527782,555774,624523,760729,496510,1031686,255693,829154,361063,1023930,467813,739548,857236,891688,136593,921993,1025145,168794,73606,1024129,1043215,631959,54656,345411,1043377,1006830,222374,978668,444123,1022512,195691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]