SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046526 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046526 [ RunTime:0.001473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (676328,746169,796827,933418,988103,887760,650172,817091,908128,919438,171613,991467,497563,160514,840524,868512,490833,896517,939398,126666,551098,788417,824048,411004,283867,397499,726691,547817,273827,629961,766468,396118,507438,165094,39389,457570,646789,73162,554870,842427,659548,80180,466654,52945,377172,416065,227032,801664,71786,72677,706887,256792,76420,507056,375262,228340,131604,746195,640678,182974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046526 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046526 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]