SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 386056 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 386056 [ RunTime:0.003043s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026353,690137,850201,568187,305198,273409,532656,175732,671162,964781,76128,648620,944765,84776,369927,624546,206434,1045424,366395,131638,613772,747446,363956,1003255,706544,295895,680856,986372,137634,808230,1016727,157724,811636,648115,881512,257202,589874,522839,419843,902433,583818,520510,821924,222959,864382,19227,717481,331420,961806,144213,634137,333290,381235,839655,512397,17060,227827,162125,683426,1046536) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 386056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 386056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001383s ]