SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002691s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476909 LIMIT 1 [ RunTime:0.003152s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476909 [ RunTime:0.002784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510168,178511,1031796,819568,631893,682323,396381,40766,828102,396208,698758,792521,935590,146285,665988,771938,543456,497901,493117,491676,485293,238607,856493,981976,56971,324129,749451,975864,910255,289714,669046,493416,886311,420315,701161,645426,497856,593104,862495,616460,1029298,386632,339486,329444,229633,317336,308214,911133,983960,991958,616334,874780,701948,23312,181984,848522,454848,145094,667033,40478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001045s ]