SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432008 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432008 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (62378,452498,953790,44562,488602,316131,687585,862471,821560,562000,990645,172270,233861,892526,429904,733982,203691,687783,410281,128293,562831,1048762,3955,518520,472737,842146,618523,240023,194177,163742,176796,459121,440170,309457,364087,997210,974377,978919,904943,702422,722678,523466,738727,34056,875379,875541,704659,698783,930241,279708,861187,641501,628060,983661,50523,97403,620778,718388,604132,844184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]