SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280596 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280596 [ RunTime:0.001859s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107528,824606,502207,106256,505503,913907,601657,986881,896128,980892,418189,957167,706530,728773,159767,936918,242057,642121,336521,785636,595684,453297,65642,1029884,57224,207611,819800,519199,334279,256797,670598,361144,47439,272303,612606,323014,80448,702536,1011170,791064,458404,601530,409147,650260,347913,637350,918,1043428,125951,847839,808993,88277,363634,703763,688396,946553,687491,42235,891157,738840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]