SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044580 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044580 [ RunTime:0.002318s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004148,850656,88688,240253,166702,135156,797076,788005,300233,1023914,943591,492899,533920,435327,31051,800365,330598,734226,129877,192562,648710,604255,578218,410070,401459,1003351,735671,424756,70476,337901,1034034,400002,945495,403596,169734,731077,1014728,1022579,917405,461383,658726,996367,331472,431973,167039,186019,673653,410823,468589,795970,367000,680170,57475,628993,140452,844374,889032,207075,548624,874834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001934s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]