SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447407 LIMIT 1 [ RunTime:0.001323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447407 [ RunTime:0.004030s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120656,498496,501597,337627,539929,152020,86156,311164,338215,447416,388933,839817,837462,512127,930843,945671,578284,1022348,30653,520850,134056,962584,916814,477015,804671,649278,708436,739496,658505,223194,843091,175489,1004880,917837,702598,214576,862881,104273,366351,293409,928990,779998,622097,974336,35805,996248,620395,795261,465249,8840,1040347,843598,870147,325443,937601,845725,600957,171568,508918,732044) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000693s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]