SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468403 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468403 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535814,55288,1007841,1007930,756412,242522,718304,251655,503781,42309,177264,1028471,78815,782216,900443,692372,756097,918264,312036,743130,470818,246657,68444,889842,442148,82488,846119,1022681,571609,395094,819733,295435,1018279,498871,204389,798898,1000404,386650,814728,918389,80263,88420,1045545,463829,51411,705674,8054,772829,352644,721321,422386,935786,222472,346302,981589,378997,99629,201125,518019,503012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]