SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261049 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261049 [ RunTime:0.002534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019477,715589,918456,915508,32099,695420,448993,541878,558002,731359,890695,179113,736877,566792,824821,947334,1014025,951936,192532,831476,128548,613888,675297,305156,376218,60602,404954,219173,888296,962577,901588,806563,820450,91008,527493,928051,876468,193922,739366,175210,255532,214738,846429,424071,466434,771794,710910,912766,236105,555659,773702,547506,298005,867842,213968,655697,307813,310722,119458,235242) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261049 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261049 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001154s ]