SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504338 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504338 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (910965,440445,668084,830531,590362,974900,982808,388983,793496,949922,664158,874449,709368,241566,210886,172298,463406,664330,668683,320579,783916,649067,989028,732749,44417,177197,1448,919123,222007,63378,103677,438334,23326,307909,887586,852540,279463,769613,680735,881634,139611,12063,725506,248967,510552,815030,390856,48975,900910,464940,750756,693018,211022,476915,997494,465172,701521,709694,308103,623020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504338 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504338 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]