SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 206374 LIMIT 1 [ RunTime:0.000690s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 206374 [ RunTime:0.002951s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425016,1013232,841673,562623,944137,495776,382605,158451,108141,117007,929881,1001705,233604,108091,549854,109626,861552,321275,322295,384709,372861,653844,624319,420756,277699,49262,137908,776297,936534,451269,293119,395888,1026386,128951,123489,171390,635720,880996,623684,980230,496278,1040324,614350,18292,276362,103550,56019,982892,825997,848597,373164,968438,180652,66620,894863,8477,318975,86111,457083,311483) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 206374 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 206374 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]