SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001821s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538841 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538841 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (910692,23707,439002,862281,238914,745020,667934,406521,536562,801355,919333,185642,5854,177682,811956,995287,139613,835394,670693,152216,573288,462180,357229,153469,103436,572650,865364,843428,245111,58219,42699,405081,164548,673239,83587,99924,613125,436902,99978,1011349,1025119,718512,1047298,150749,148366,673275,1034467,103013,909655,264094,274031,1033626,934337,657944,104694,213538,1022796,334315,272790,404334) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]