SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106821 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106821 [ RunTime:0.002487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654633,827957,432044,756725,401642,668586,922431,52142,46240,356974,58583,339548,1040651,16420,356163,337887,436344,905236,591713,173655,550800,52105,297566,50060,551572,845387,485403,168565,818888,552060,810941,125019,875287,124334,1036188,799229,721491,742935,869065,1001032,312633,919506,186563,942836,837037,35558,4318,652582,594035,598724,431828,905922,771563,557943,994087,59124,441748,683481,532845,52980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004183s ]