SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 268681 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 268681 [ RunTime:0.002286s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037813,864514,286240,613872,655217,852105,616389,293129,437355,804783,721134,781137,423949,268474,993275,538878,65254,12438,239097,976202,515805,255698,35996,391751,810687,902003,265411,201615,674107,394479,578747,175632,491804,245846,1013541,354624,407237,686709,281823,102258,915463,199492,525365,923441,803316,879628,132570,625131,201274,533577,846228,561406,512548,506264,1029641,19911,595169,645849,98573,842499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 268681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 268681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]