SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534063 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534063 [ RunTime:0.002328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (910145,219981,26086,608390,786442,765076,293309,235654,830147,252388,798861,807756,971804,546381,954007,753341,437643,483139,355649,21710,118323,499300,124866,459866,27061,187101,1027562,896953,175934,163403,173783,661469,197344,693822,119469,46518,709800,572136,396021,805847,715342,331868,714491,211939,211507,447815,734067,151517,408313,11474,357546,385403,836972,402049,640326,492825,712694,423203,154046,188784) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]