SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 731417 LIMIT 1 [ RunTime:0.001398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 731417 [ RunTime:0.002771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497060,185799,230239,307817,814526,676635,422020,1003640,735541,197918,751045,427731,49735,50184,833465,120244,1045365,188021,200241,256450,902810,232016,724411,97982,135691,215618,1045664,150624,446541,976857,70210,351804,176664,365070,789273,421205,43184,157206,844094,725190,190354,1026453,656540,657605,366432,279199,90010,399105,693615,967395,471740,108525,153854,744624,678065,778331,326740,371290,722578,216396) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 731417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 731417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004903s ]