SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 953551 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 953551 [ RunTime:0.004256s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318938,204180,345415,134109,856397,155830,440117,611944,383890,308774,934248,168704,316522,59165,434643,71691,357118,334911,680293,633394,697180,363497,641148,391821,931625,822344,1044855,475350,278218,766712,507868,1036179,270822,905026,285710,726809,474829,514624,421819,1030540,676136,69398,1044769,295937,247424,769245,129128,73505,447097,522899,623793,902866,652746,612088,58461,455737,88507,1022015,667023,895443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 953551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 953551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]