SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584281 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584281 [ RunTime:0.001478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046685,117051,227276,338741,133589,643389,133225,949372,965954,1030353,336903,291398,711859,78954,579183,654026,312460,805538,748828,347232,960004,471716,1044460,866734,635539,879363,76312,672025,43094,328678,465679,358026,368141,506142,762594,696120,235351,752802,94294,298285,46855,993434,208003,166684,248773,113391,527379,737540,380320,449903,801875,751546,416779,673246,869905,755115,236153,19710,21581,868622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]