SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501721 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501721 [ RunTime:0.004287s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845322,522185,1024074,720881,479394,990124,203471,998140,482406,1019423,208342,331261,411612,456389,40418,781180,600211,688168,967453,880152,799947,574251,890350,969354,922218,772331,997833,486886,655589,346224,25576,5140,449083,823599,627956,268057,659577,409999,871040,140363,242881,633058,982058,764219,240819,819703,179590,333945,671999,706698,226685,366574,911145,320738,44324,215675,209583,991932,476209,416653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501721 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501721 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003913s ]