SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380210 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380210 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210041,739311,502691,965864,789421,610722,347528,934374,360062,97294,183857,553192,371873,68033,385440,279369,112275,982813,799719,792219,757319,848601,907339,371254,508733,445435,303487,430050,527404,128447,1031948,795120,758242,383394,750366,612658,754336,427082,45542,342772,951787,275704,588645,145165,809338,374912,724964,809208,376126,521485,538522,188246,771622,379789,474462,390628,463159,139952,4890,281349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000698s ]