SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403837 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403837 [ RunTime:0.003979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703748,1021174,9800,643635,246300,592052,735061,338533,215132,382255,394233,896387,587967,905430,1028759,522867,756732,10839,216665,608324,1009515,811162,637361,307825,225137,593574,94283,664079,354546,863500,68268,799482,612607,179753,810098,1042724,463800,852163,949555,445615,728110,49162,375216,380695,335046,800115,472114,804846,1016979,397957,515419,953703,751435,925113,524624,247845,765924,1018699,172319,429046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403837 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403837 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]