SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194999 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194999 [ RunTime:0.002160s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114136,635480,632068,749321,261369,857028,840352,809849,961002,362308,47368,917616,904587,146486,361611,118262,779260,1008254,429840,774316,648630,697437,929388,49087,43572,939504,318472,564638,881750,911787,51780,430015,180989,10924,638440,658369,187165,458582,477703,610019,317189,265488,254897,501448,233054,496338,310782,821478,538496,524971,954121,273985,655692,559796,904087,821059,374865,984437,828166,303725) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194999 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194999 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]