SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 220 LIMIT 1 [ RunTime:0.000646s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 220 [ RunTime:0.004026s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (213185,144666,160615,669115,808974,301489,432355,94445,140715,662149,727732,223487,1006579,309104,210705,135163,127651,97542,799008,929952,502455,698159,941743,233672,710641,271815,31638,374484,161448,176441,842829,852257,77045,1024311,187184,297174,407351,1013805,278547,279967,679017,321618,57520,794425,634394,807257,763027,28796,311711,550236,645771,878229,624333,513973,930095,585471,962636,990500,626947,588063) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000702s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]