SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285403 LIMIT 1 [ RunTime:0.001090s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285403 [ RunTime:0.001542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (974098,916985,224403,1006435,33353,719378,1005232,882888,357859,497033,57907,917028,297399,93778,767456,872897,245884,970338,397175,306702,486018,594399,194724,283848,222748,568839,116058,454433,869268,978939,870108,187362,577672,657967,461124,1007459,871936,778765,225141,42696,968588,474470,582709,798190,407154,472100,864337,408784,181789,368948,674250,986400,423610,610726,294964,227748,218745,479180,365505,847302) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]