SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001556s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409327 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409327 [ RunTime:0.002096s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (712849,501552,922678,918905,194307,982841,923924,879340,443834,676457,113520,735371,334237,730974,635511,752713,561145,100478,181467,657023,976328,147460,786360,687822,924486,1023545,516828,47519,1043332,508452,580937,716453,142925,506626,437927,972838,206194,877914,976566,786509,228209,482600,721395,117778,30747,853890,801220,937952,543323,776008,602883,322192,716174,619813,885254,71315,359533,265736,362602,531099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409327 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409327 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001254s ]