SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575191 LIMIT 1 [ RunTime:0.001316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575191 [ RunTime:0.011829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (347208,551005,573727,1044243,128753,631955,854077,170498,336196,207311,323128,719050,891156,158827,440317,474357,456382,584387,792604,635976,523441,892213,736817,1000853,207336,415496,79195,319249,116896,15508,892704,253141,777742,686545,779432,519183,1003565,31588,763434,166619,755951,420916,298320,709836,333214,145561,187743,974210,417268,505602,540762,292295,941463,617624,367068,244979,421690,935524,989437,518479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001456s ]