SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477831 LIMIT 1 [ RunTime:0.001110s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477831 [ RunTime:0.001196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (30302,630846,574179,305815,48997,968523,565,194912,941180,235710,490548,638836,387338,663200,639338,1009139,44688,486156,881178,558212,442287,476182,403660,950418,438862,283705,803775,578904,786919,998581,362314,614064,709951,236661,774668,830312,811061,603977,560670,252586,55432,480292,667622,481081,365429,1036325,703576,673219,665242,283231,476993,727909,446226,356910,722134,436573,671980,126075,755011,452532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]