SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 650438 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 650438 [ RunTime:0.001916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402954,164598,34111,52014,494340,466833,980743,53113,637089,395778,626088,980605,583934,386665,550938,629381,569738,307816,269651,490180,637334,604695,694886,634941,368347,529642,1017730,703003,866646,171109,514898,425473,641407,781506,374902,851319,438505,734772,844336,756208,457192,723886,117569,608234,1000184,127874,605923,447041,649445,801364,927036,352964,589126,945143,827107,249892,851318,35071,606528,343028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 650438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 650438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]