SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318040 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318040 [ RunTime:0.001599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111593,953160,172160,75243,126074,923261,985808,561968,624203,925228,637537,180894,601999,543943,688723,899016,816920,886324,535022,1036357,24324,349218,526264,515667,519390,207120,1025835,469555,385341,568093,831199,1031774,325776,788167,656936,525894,457816,789670,265079,475279,583192,482068,403223,611767,777378,489323,608760,388639,624012,160974,115327,373286,623620,821704,303190,189206,202126,880375,451710,176713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]