SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403982 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403982 [ RunTime:0.006461s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335581,534657,192645,754289,255916,934216,101837,253325,985643,936136,484603,115758,52134,430795,617326,688750,424774,494130,374157,58952,910143,361877,745983,204211,920884,1002720,1137,89316,428993,320649,644229,182441,155627,426103,94516,276640,402243,684945,312890,227696,204918,74358,1025490,178712,466686,450847,177998,404965,141775,100356,969146,1045865,763473,268930,83343,553434,1038982,916502,744292,179547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403982 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403982 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000390s ]