SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001632s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405157 LIMIT 1 [ RunTime:0.000586s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405157 [ RunTime:0.002914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199234,169091,233758,603974,750326,494559,142194,1006471,815419,374756,432910,950736,699293,295227,645549,416484,740874,389504,518764,68634,651812,8427,321710,461597,692093,646529,493644,250243,12158,436593,985446,1004827,898709,907410,675559,333667,288769,168668,447891,944882,956662,1048590,838798,779784,214764,1040102,239643,474963,747303,408493,210123,702511,695040,388113,319190,387635,912841,905323,632075,2589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003653s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405157 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405157 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]