SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002082s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020629 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020629 [ RunTime:0.002316s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788628,755519,657587,740574,405272,661260,549060,883584,258521,559449,118467,963004,867554,842885,686675,940785,972411,995403,651705,933089,892612,469661,103174,487834,1024074,81194,215396,517265,748305,392325,743449,86341,808325,483026,237807,775710,89430,587881,569086,707864,66376,75266,254541,366743,431571,463985,899457,208220,899317,265875,883813,765627,1017247,62105,101829,899352,524944,420415,33411,224930) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020629 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020629 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]