SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407868 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407868 [ RunTime:0.005181s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (390993,226885,653180,95170,714945,887859,727414,982392,1002035,576957,123874,924968,335817,835003,1044275,453998,869117,761608,504163,587708,500382,736229,361005,295150,282022,878782,767095,620330,728041,155205,674142,451724,183769,482406,86487,1040371,861454,345871,947766,1014772,948142,749687,291322,480767,150955,441435,121576,204687,736557,892069,312988,783360,1016778,428069,307138,878194,1019781,559417,1028130,946054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002930s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407868 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407868 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]