SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509095 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509095 [ RunTime:0.001478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384571,581546,159376,167579,399040,759672,234945,809044,282446,803442,756924,968937,503234,203001,350403,391045,150453,260488,965849,640680,959718,499076,285806,639563,190727,868646,112923,66770,952510,864497,90275,795991,1034751,309322,236064,874268,950539,832154,702224,641841,712480,444836,955035,346296,691189,359600,418361,29401,173247,378624,1029889,659415,798640,845161,283118,730797,977983,473705,909026,613007) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509095 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509095 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]