SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345236 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345236 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503211,52483,334895,952778,351935,437774,233151,192287,278683,803126,897284,249197,694889,72519,388374,681203,450063,992067,416038,1043526,997805,158351,88226,169819,354301,412648,41030,347492,1007031,799075,765638,927174,786773,637480,411664,395521,682885,783722,948553,582972,697684,947127,405519,219066,89505,915174,543910,413668,736780,653473,370462,699954,418754,720650,222264,440239,460125,39116,844191,978469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345236 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345236 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]