SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002850s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 905199 LIMIT 1 [ RunTime:0.003719s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 905199 [ RunTime:0.002751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120248,810584,48152,1047756,736946,377722,224100,985603,1006460,786141,659139,324703,304785,551860,302975,115602,645690,822810,544484,638245,515607,986038,903064,529593,916004,91553,771516,975040,463090,830358,13219,11940,843871,960419,114747,515489,915863,997138,111156,774713,943363,909109,683032,897852,860298,854682,224500,302193,1009481,353376,751108,66278,858056,212698,274220,619189,448255,866073,661026,1037512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001747s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 905199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 905199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001360s ]