SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517841 LIMIT 1 [ RunTime:0.000571s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517841 [ RunTime:0.003172s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736398,94706,64046,297330,129163,52972,240662,167116,913950,42761,640564,525444,470224,592216,948801,381123,391324,223188,927913,43161,204909,878006,901063,979789,775315,392637,215896,85433,202796,3292,1002628,243297,724302,318819,910694,211119,497917,905764,749541,912907,1035797,786566,914736,975110,251608,195348,737156,954392,489396,674078,191745,96508,189728,97940,428928,786338,824089,507924,451517,47450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003830s ]